CREATE TABLE [dbo].[Participiant]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[FullName] [nchar] (255) COLLATE Arabic_CI_AS NOT NULL,
[Mobile] [nchar] (12) COLLATE Arabic_CI_AS NOT NULL,
[Email] [nchar] (255) COLLATE Arabic_CI_AS NOT NULL,
[HomePhone] [nchar] (10) COLLATE Arabic_CI_AS NULL,
[CollegeID] [int] NOT NULL,
[UniverstyID] [int] NOT NULL,
[WorkshopID] [int] NOT NULL,
[InterviewID] [int] NOT NULL,
[EventID] [int] NOT NULL,
[Barcode] [nvarchar] (50) COLLATE Arabic_CI_AS NOT NULL,
[Comments] [nvarchar] (max) COLLATE Arabic_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Participiant] ADD CONSTRAINT [PK_Participiants] PRIMARY KEY CLUSTERED  ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Participiant] ADD CONSTRAINT [FK_Participiant_College] FOREIGN KEY ([CollegeID]) REFERENCES [dbo].[College] ([ID])
GO
ALTER TABLE [dbo].[Participiant] ADD CONSTRAINT [FK_Participiant_Event] FOREIGN KEY ([EventID]) REFERENCES [dbo].[Event] ([ID])
GO
ALTER TABLE [dbo].[Participiant] ADD CONSTRAINT [FK_Participiant_Interview] FOREIGN KEY ([InterviewID]) REFERENCES [dbo].[Interview] ([ID])
GO
ALTER TABLE [dbo].[Participiant] ADD CONSTRAINT [FK_Participiant_University] FOREIGN KEY ([UniverstyID]) REFERENCES [dbo].[University] ([ID])
GO
ALTER TABLE [dbo].[Participiant] ADD CONSTRAINT [FK_Participiant_Workshop] FOREIGN KEY ([WorkshopID]) REFERENCES [dbo].[Workshop] ([ID])
GO
